package com.fishery.logistics.mapper;

import com.fishery.logistics.entity.Path;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fishery.logistics.entity.vo.PathVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author run
 * @since 2021-01-23
 */
public interface PathMapper extends BaseMapper<Path> {

    @Select("SELECT logistics_path_station_id, logistics_path_arrival_time, logistics_path_departure_time" +
            " FROM t_logistics_path WHERE order_id = #{orderId} ORDER BY logistics_path_arrival_time")
    public List<PathVo> getPathVosOfLogistcis(String orderId);

}
